2017-03-27 - 6716 - Enhancement - OSA410 Enhancements & Issue fixes #CrystalReportsSupport
ENHANCEMENT
17594 - OSA410 Report Enhancements & Issue Fixes
Problem Summary
Need to fix OSA410 report issues and add more enhancements.
Admin Info
Purpose
|
Need to fix OSA410 report issues and add more enhancements.
|
Requested By
|
Matthew Bolles
|
Spec Created By
|
Dhananjay G
|
Spec Created Date
|
03/27/2017
|
Spec QA by
|
Uday Kumar P
|
Objects
|
OSA410 report
|
Document Status
|
Complete
|
Estimates
SNo
|
Activity
|
Estimation in Hours
|
1
|
Research
|
00
|
2
|
Documentation
|
02
|
3
|
Development/ Config
|
90
|
4
|
Unit test
|
20
|
6
|
Other activity(BW)
|
03
|
|
TOTAL
|
115
|
References
Prior Tickets
17594
Documents
None
Spec Changes
SNo
|
Change Details
|
Requested By
|
Requested On
|
1.
|
Can the sales rep parameter be set up so that a value of “ALL” can be input? and date formats display wrong and query link for rejection lines.
|
Matt
|
03/30/2017 - Email
|
2.
|
Add 'Group By' prompt in the report for showing the data customer/week date.
|
Matt
|
04/07/2017 - Email
|
3.
|
Need to apply the same date format to 'WEEK DATE'.
|
Matt
|
04/25/2017 - Email
|
4.
|
Can you change the date parameter to be a range with an upper and lower value based on the requested delivery date field?
|
Matt
|
05/04/2017 - Email
|
5.
|
Need to analyze provided examples of orders in production with particular scenarios and validate with modified report.
|
Matt
|
06/13/2017 - Email
|
Functional Requirement
Purpose/WHY:
Need to fix OSA410 report issues and add more enhancements.
In Scope:
OSA410 report for Global Region.
Out of Scope:
Other Regional versions.
Solution Summary
1. Need to implement logic that when the date parameter is input, it will add 5 days to it and fetch the data for that period. For Eg. If date input is "03/30/2017", then the report fetches data from 03/30/2017 to 04/05/2017.
2. Need to fix both Week date and Confirmed date which are shown in the report as DD/MM/YYYY(UK format) which is correct, not sure if the issue exists on the users machine.
3. Need to link the data related to Rejection code status which is available in a different BW BEx Query with the current report, to remove the any orders with rejection lines. But this may have performance impact on the report.
4. Need to add Sales Rep parameter to the report .
5. Need to provide the below formula for Formatted Week Date:
numberVar Y:= YEAR({@WeekDate});
numberVar M:= month({@WeekDate});
numberVar D:= day({@WeekDate});
CDate(Y,M,D).
6. Need to test all the provided scenarios with updated report successfully.
7. NEC counterpart need to test all the scenarios with user.
Solution Details
1. Date parameter is not fetching the relevant results when the specified ‘week date’ is passed. Currently, the date parameter input is set as the requested delivery date. So when they run the report with a specific date input, it only displays orders that have a requested delivery date equal to the date that was input. The business would instead like to be able to enter in a date for the parameter input and have the report return all orders that have a requested delivery date that falls within the week that contains the date that was inputted as a parameter.
2. Confirm Date is not displaying correctly for users in UK format(DD/MM/YYYY) - There has been issues with the Confirm date as well as the ‘WeekDate’ field not displaying in UK format. Also “Picking the orders 3246264 and 3373728, the orders are grouped for January whereas the RDD in the orders are scheduled in March and June. So it appears that even though the RDD date is in march or june the ‘Weekdate’ is showing as January.
3. Orders with Rejection codes should not be shown in the report.
4. The business would like sales rep added as a parameter input to the report.
5. The business would like the following behavior for the week input:
i). Preferred: if the user enter let's say Thursday the 30th of March, the system would look between the Monday 27th to Sunday the 2nd April.
ii). If not feasible, this would be from the Thursday 30th to the Wednesday 5th Apr.
6. Added new parameter for Group by Customer/Week date.
7. applied the same date(Confirmed date) format to 'WEEK DATE'.
8. Validated all the scenarios with BW BEx query.
Issues
When we add Orders with Rejection codes query to the report, the report performance is worst and so this change was reverted.
Release Information
2017-06-20 - 17594 - Rel Notes - OSA410 Enhancements & Issue fixes